# -*- coding: utf-8 -*-
from common.excel_helper import ExcelReader
from k3_data_report.utils import insert_k3_dp_tb

__author__ = "Ypf"
_date_ = "2019/10/11-9:06"

#insert_k3_dp_tb(r"E:\favor_proj\favor_center\git_local\favor_new_data_report\k3_data_report\品牌+产品经理+产品助理+产品级别.xlsx","Sheet1","insert  into k3_gysry(pp,cpjl,cpgly,cpjb,id,sjsj) "
 #                                                                                                                            "values ('%s','%s','%s','%s','%s','%s') ","2019-10")
# insert_k3_dp_tb(r"E:\favor_proj\favor_center\git_local\favor_new_data_report\k3_data_report\客户名称+客户经理+客服+销售经理.xlsx","Sheet1","insert  into k3_khry(khmc,khjl,kf,xsjl,id,sjsj) "
#                                                                                                                              "values ('%s','%s','%s','%s','%s','%s') ","2019-10")
# file = ExcelReader(r"E:\favor_proj\favor_center\git_local\favor_new_data_report\k3_data_report\品牌+产品经理+产品助理+产品级别.xlsx","Sheet1" )
# list = file.get_excel_data_list()
# print (list)
insert_k3_dp_tb(r"E:\favor_proj\favor_center\git_local\favor_new_data_report\k3_data_report\供应商+品牌+产品助理.xls","Sheet2","insert  into k3_gyry(gys,pp,cpgly,id,sjsj) "
                                                                                                                             "values ('%s','%s','%s','%s','%s') ","2019-10")